Calculate columns
Purpose of this building block
The Calculate columns building block allows you to perform calculations or conversions on existing values. Thereby create new columns for values you are interested in.
Possible use cases
- Calculate the total column by multiplying quantity and price
Configuration
Click on the reload icon to scan the Google Form for modified, added or removed fields.
Only unbound input parameters are activated in the form dialog, so if you are using the script multiple times you may need to activate the table and expression parameters.
When creating new columns on the fly by defining them in your expression they will not show up in the Ultradox Template Editor. You'll have to enter them into your templates manually.
Useful combinations
Example: If your table contains a column called amount which holds the amount in cents and you want to convert it to dollar, you'll have to divide the amount by 100. You then want to create a new column called total by multiplying the amount with the quantity. You can perform both operations using the following expression:
Please note that you will have to access the columns by using the row prefix. If you for example have a column called quantity you'll have to use row.quantity in your expression.
row.amount = row.amount / 100; row.total = row.amount * row.quantity
Questions and Feedback
If you have any comments on this guide, feel free to add them right to the Google document that we are using to create this site.
If you are not yet member of the Ultradox community on Google+, please join now to get updates from our end or to provide feedback, bug reports or discuss with other users.
Last Updated:
